UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'MhYlowa+H1Yx97sMdws48GpycV5IbFibf3nXudaru10=' 
WHERE 
  key_id = '5496d235484b6f5cca49d755ef38e793759dbf7418a8dc0a56f9ef3fc533a194' 
  AND (
    token = 'MhYlowa+H1Yx97sMdws48GpycV5IbFibf3nXudaru10=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039