UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xz6HYr3GptG/WJ1KGIxZu6Z7vnLjpMaF243AGQxgcoA='
WHERE
key_id = 'e8a2a2a11b972ea176693e26044e4cfef5d7b7c0475cc34f0e26388f457f6610'
AND (
token = 'xz6HYr3GptG/WJ1KGIxZu6Z7vnLjpMaF243AGQxgcoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)