UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XIPOoHnIBYryLONiQyroLM80sl4wXGdkc8Ha8yYjFeQ='
WHERE
key_id = 'e321228403f025166033015e049f70d6b842f62aeb345106fc29e513b16e9f64'
AND (
token = 'XIPOoHnIBYryLONiQyroLM80sl4wXGdkc8Ha8yYjFeQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)