UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fOq6kLFiSvYCL6giJGBiDauPfi7/1VMc39vQz+y4dj8='
WHERE
key_id = 'f3cfb07916c0a70f75c719a1c0b1faef06940dd3604836fc1db6fbbf5b16ef39'
AND (
token = 'fOq6kLFiSvYCL6giJGBiDauPfi7/1VMc39vQz+y4dj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)