UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'L9fGlJg8P02hFK9aNbwhFqSYJrmRs5eLgAEaPxPNHJQ='
WHERE
key_id = '870a4dc3cabf22a03de3bbad3030c20a21a38724980d3df8484b6842228bbb97'
AND (
token = 'L9fGlJg8P02hFK9aNbwhFqSYJrmRs5eLgAEaPxPNHJQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)