UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7zN0ZVCtPJNK29bIE6SAvno8sV3h9ltln8fPRFJdaKo='
WHERE
key_id = 'ffac6edefead3f9950a82b49df524e6b2700ad539b84f984034ae41b97697f48'
AND (
token = '7zN0ZVCtPJNK29bIE6SAvno8sV3h9ltln8fPRFJdaKo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)