UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'w2B1HHLGPKa94cVPM/9sLNgqPhv09y1afleRYxz8i1s=' 
WHERE 
  key_id = 'a82415900c9e4b6d1f0f1278fbf66f42ec4b7e75986ee0f8098882f8a086c092' 
  AND (
    token = 'w2B1HHLGPKa94cVPM/9sLNgqPhv09y1afleRYxz8i1s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034