UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9IGGXUPzyf5LqmjrHJXieEuah6bPGMJ2wG5RWeeAPX8='
WHERE
key_id = '687c93d0594495e1efbb20c235c534004e8e15dc50a236b519853fd8803df5a3'
AND (
token = '9IGGXUPzyf5LqmjrHJXieEuah6bPGMJ2wG5RWeeAPX8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)