UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'j8vxqo6FHZJ487//g9jCUQmRYxmGVjSKmuF85+r2vuQ='
WHERE
key_id = '35df553035906433711b0abdd4523c132984ba7ae456692ce5c7e6a0119d4730'
AND (
token = 'j8vxqo6FHZJ487//g9jCUQmRYxmGVjSKmuF85+r2vuQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)