UPDATE
tmall_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zJvU8KQ4mmiEp9XDZ+HUbjbOa5pP9KUEifWM42iJ0ew='
WHERE
key_id = '57fe64be7ad8b3510e99904d4c9a1427534f78ca0944973e49ba59b959e7d3de'
AND (
token = 'zJvU8KQ4mmiEp9XDZ+HUbjbOa5pP9KUEifWM42iJ0ew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)