UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'B49NXZnE3dDhZrnM7onknI6ugzF9jpw8ISya+aP566E='
WHERE
key_id = '23d96ea69851a120ac4c3b8304e496f5d414bfebe7dd8ba88e276145c6c474c7'
AND (
token = 'B49NXZnE3dDhZrnM7onknI6ugzF9jpw8ISya+aP566E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)