UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9yOhD79zPP+ZgUOG7fugHAehd7S9WbXCsnxA+ter8Pk='
WHERE
key_id = 'd79f8db4612c65f564296dacdc7206b80d3370e89c778462d110570b1ac7d7a0'
AND (
token = '9yOhD79zPP+ZgUOG7fugHAehd7S9WbXCsnxA+ter8Pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)