UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QfPTQACGU2BJAXitgXIgtuYl3DV1yHLaz4Pfb/+E/24='
WHERE
key_id = '4f5bd5487582907617fbed7d5911a207b87cebf9922880589023e5e1107ca828'
AND (
token = 'QfPTQACGU2BJAXitgXIgtuYl3DV1yHLaz4Pfb/+E/24='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)