UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HAf/+iXT0jAKGiv0uWbnjfKgbAUo26dxlHUY7N+YszI='
WHERE
key_id = '8bebdcf56a5a159bbf0d3c6ea98b87ca3655b58bb2c2971388fd2ff12d20e6bb'
AND (
token = 'HAf/+iXT0jAKGiv0uWbnjfKgbAUo26dxlHUY7N+YszI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)