UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SByi0UCpX3EsuNL6SsPTFofww6mSwrm8PO0XWvfRMA='
WHERE
key_id = 'b7427ddaae918c4839533f1de8a2afdb3ab328d090bd5ace01091cff868771ce'
AND (
token = '6SByi0UCpX3EsuNL6SsPTFofww6mSwrm8PO0XWvfRMA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)