UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Fat1uj3yMJP18Z8yn/IBdHT0N0cpZ8GNzF+YGMfMbCE='
WHERE
key_id = 'dd01e81cb8cb16f9af19b14daa4b06c61dbf86a6ae86c8f6eb6aad9611f34da3'
AND (
token = 'Fat1uj3yMJP18Z8yn/IBdHT0N0cpZ8GNzF+YGMfMbCE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)