UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CNcDbaht1UJujHL/ulG4UndSsKb0ZmqJHjM0ia5BOfg='
WHERE
key_id = '504c8b0d921b4037da66c8bf090e03ea4d466da6259668b20d3a39f2fe31bed7'
AND (
token = 'CNcDbaht1UJujHL/ulG4UndSsKb0ZmqJHjM0ia5BOfg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)