UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kcvHI+zGk58Q93ZvHlEbD3iGGr0thXYi0O36P0ZvY4w='
WHERE
key_id = 'd79ed6fd79e7282ae0f9a1987b3fcc615212bfdf99816a19f7c0ea93a7e7f46a'
AND (
token = 'kcvHI+zGk58Q93ZvHlEbD3iGGr0thXYi0O36P0ZvY4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)