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