UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3WQor3jwtB+gAu713i9J/z5F/cf2bd59F8YaXWbJj40='
WHERE
key_id = 'cd79caebf2695585e76546fbfa974a9225fd3817a08c32af598fdbea54d3b56b'
AND (
token = '3WQor3jwtB+gAu713i9J/z5F/cf2bd59F8YaXWbJj40='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)