UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a8TeBwjjLEhtahwI9/5/7MhfqZVCtnbkXrBuqN6744I='
WHERE
key_id = 'f644dd49b04b13f2b19960d0b7e12f48a17d03e1f80ef8734c2ae78d567d7d52'
AND (
token = 'a8TeBwjjLEhtahwI9/5/7MhfqZVCtnbkXrBuqN6744I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)