UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HS7tmTFUW7dUJAU39vGv+8jZELKUG8SSA8JQn0K4cAg='
WHERE
key_id = '9ec95162ecce646a04ccaffbf18f01d9ce96fc2bd34d5c183530f44f62f58877'
AND (
token = 'HS7tmTFUW7dUJAU39vGv+8jZELKUG8SSA8JQn0K4cAg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)