UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pBzECq9n7RX3ThmUHWGXYFTnpUv8+ksG0u3OPUrWVk='
WHERE
key_id = 'b13779b67e7035b9dfd151a8deab9ea00dafb970bf47f9085cfe5d6aaef632be'
AND (
token = '9pBzECq9n7RX3ThmUHWGXYFTnpUv8+ksG0u3OPUrWVk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)