UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNOfh+RFEz4xYBgoHgqGbUQPp72QGIvqP5CY7jqhHgc='
WHERE
key_id = 'b9371fbcc1b69bbc0de5998128a8c272d1b76dadc35aed1ab84b39ca18789d36'
AND (
token = 'pNOfh+RFEz4xYBgoHgqGbUQPp72QGIvqP5CY7jqhHgc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)