UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4xPs7HWJxX+6nNOn2Tm1kVy1AYtWqFyF1EZEJbUParY='
WHERE
key_id = '1ddba8650ea38de87b3695335d01112b8f28902796a0ff0370bd4e5b0c9d9895'
AND (
token = '4xPs7HWJxX+6nNOn2Tm1kVy1AYtWqFyF1EZEJbUParY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)