UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LZQmVSNdwqQ935yEZ+QbIDjZhLpMpKafrS6hZDmnJIU='
WHERE
key_id = '3d905fcd95d96c4cfe8486ce8eb174a9425ef48bb59a1bac2142ad2a362bd647'
AND (
token = 'LZQmVSNdwqQ935yEZ+QbIDjZhLpMpKafrS6hZDmnJIU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)