UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IvYT2lVZGqfB3NfzbsIn9ZbnEEv2O6HKJlqrDzUdtPA='
WHERE
key_id = '8d9997f283b70c8158344727106e47dc7dcf4676d023cde7e4b59f9dfd4ef3f7'
AND (
token = 'IvYT2lVZGqfB3NfzbsIn9ZbnEEv2O6HKJlqrDzUdtPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)