UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCVQFYYDldKyeI7/sD6vOUQsTZYLA1O7mi4zSJ/Y6Qo='
WHERE
key_id = 'f0acd47b8ffb5b6eed90b686e4678d14826084a58507129bb0081728fff0352d'
AND (
token = 'QCVQFYYDldKyeI7/sD6vOUQsTZYLA1O7mi4zSJ/Y6Qo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)