UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Kya4OlxDU8DQZMK9tR7x3XAK4CYmmjAI3wP6BUS/SxM=' 
WHERE 
  key_id = '3291401a0fb93adbf15b0a57a738e50a28178849c9e0d89c15f6ea71884a835d' 
  AND (
    token = 'Kya4OlxDU8DQZMK9tR7x3XAK4CYmmjAI3wP6BUS/SxM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023