UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YjMkxrlPmsirmzc8vGoFlglNAgeQP6zlS87djsFeeE='
WHERE
key_id = '59d54c7844ee7a31acd656604438b40ba1965c6385be4da05ed91273aa67e580'
AND (
token = '8YjMkxrlPmsirmzc8vGoFlglNAgeQP6zlS87djsFeeE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)