UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2e6HrfhMvOar3a1Q3cdcKlLxt1cf9AnVlIVAw5nXNNA='
WHERE
key_id = '23637d96bd885c2801fca65c73aa2ffb597bc7f0275a8968510396e1432d54a3'
AND (
token = '2e6HrfhMvOar3a1Q3cdcKlLxt1cf9AnVlIVAw5nXNNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)