UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Z2gQjwE4Apfl76hN66AjRSBya83svy/hs58tUc36cO0='
WHERE
key_id = '776fb4766285ef7447def0373d7533c1ab5d6037d156c5ac175097b8f5616914'
AND (
token = 'Z2gQjwE4Apfl76hN66AjRSBya83svy/hs58tUc36cO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)