UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Wxbcc5IUUYEEJ4X9DB6MjC7arKVrY/J/Vj6HRFtMWAQ=' 
WHERE 
  key_id = '41393f28fa8520227f8a5343873bd2f953f2d0ed6775c6c83b7464b4bc5fdbd7' 
  AND (
    token = 'Wxbcc5IUUYEEJ4X9DB6MjC7arKVrY/J/Vj6HRFtMWAQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00599