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