UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'FYVQEd8e6ilHnunPDPNUuOp51IHiSjklwDi0uZU7esQ=' 
WHERE 
  key_id = 'c0b12dd0a561a1bda14c11ecf591d706c3a5d4edbcfecd23a14d55d0977a539b' 
  AND (
    token = 'FYVQEd8e6ilHnunPDPNUuOp51IHiSjklwDi0uZU7esQ=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027